package com.hshoesmall.demo.mapper;

import com.hshoesmall.demo.model.entity.ShoesTop;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ShoesTopMapper {

    @Select("SELECT * FROM `ranks` WHERE  sgender  ='男'  ORDER BY stimessold ")
    List<ShoesTop> findAllManShoes ();

    @Select("SELECT * FROM `ranks` WHERE  sgender  ='女'  ORDER BY stimessold ")
    List<ShoesTop> findAllFemaleShoes();

}
